package org.celery.modules.order.excel;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import lombok.Data;

import java.io.Serializable;

/**
 * OrderDTO
 *
 */
@Data
@ColumnWidth(25)
@HeadRowHeight(20)
@ContentRowHeight(18)
public class OrderExcel implements Serializable {
	private static final long serialVersionUID = 1L;

	@ColumnWidth(15)
	@ExcelProperty("目的地")
	private String destination;

	@ColumnWidth(15)
	@ExcelProperty("承运商")
	private String carrier;

	@ColumnWidth(10)
	@ExcelProperty("时效")
	private String aging;

	@ColumnWidth(10)
	@ExcelProperty("货物类型")
	private String goodsType;

	@ExcelProperty("订单号")
	private String orderCode;

	@ColumnWidth(15)
	@ExcelProperty("运单号")
	private String shippingCode;

	@ColumnWidth(15)
	@ExcelProperty("淘宝单号")
	private String taoBaoOrderCode;

	@ColumnWidth(15)
	@ExcelProperty("申报数量")
	private String goodsCount;

	@ColumnWidth(15)
	@ExcelProperty("申报价值")
	private String totalAmount;

	@ColumnWidth(15)
	@ExcelProperty("申报单价")
	private String goodsSingleAmount;

	@ColumnWidth(15)
	@ExcelProperty("品名")
	private String goodsName;

	@ColumnWidth(15)
	@ExcelProperty("备注")
	private String remark;

	@ColumnWidth(20)
	@ExcelProperty("货物数量")
	private String shippingGoodsCount;

	@ColumnWidth(20)
	@ExcelProperty("代收货款")
	private String collectionOfMoney;

	@ColumnWidth(20)
	@ExcelProperty("实际重量")
	private String weight;

	@ColumnWidth(20)
	@ExcelProperty("保价金额")
	private String stockment;

	@ColumnWidth(20)
	@ExcelProperty("包税(1包税2不包税)")
	private String isTax;

	@ColumnWidth(20)
	@ExcelProperty("收件人姓名")
	private String receiveName;

	@ColumnWidth(20)
	@ExcelProperty("收件人手机")
	private String receiveTelephone;

	@ColumnWidth(20)
	@ExcelProperty("收件人电话")
	private String receivePhone;

	@ColumnWidth(20)
	@ExcelProperty("收件人地址")
	private String receiveAddress;

	@ColumnWidth(20)
	@ExcelProperty("邮编编码")
	private String zipCode;

	@ColumnWidth(20)
	@ExcelProperty("身份证号码")
	private String identificationNumber;

	@ColumnWidth(20)
	@ExcelProperty("派件人名")
	private String participation;

	@ColumnWidth(20)
	@ExcelProperty("英文品名")
	private String goodsEnglishName;

	@ColumnWidth(20)
	@ExcelProperty("门店号码")
	private String storeNumber;

	@ColumnWidth(20)
	@ExcelProperty("门店名称")
	private String storeName;

	@ColumnWidth(20)
	@ExcelProperty("客户编号")
	private String customerNumber;

	@ColumnWidth(20)
	@ExcelProperty("备用1")
	private String alternate1 ;

	@ColumnWidth(20)
	@ExcelProperty("备用2")
	private String alternate2;

}
